﻿CREATE TABLE [dbo].[UDS_Task] (
    [ID]             int          NOT NULL identity(1, 1),
    [ArrangedBy]     nvarchar(50)  COLLATE Chinese_PRC_CI_AS NOT NULL,
    [Subject]        nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
    [Detail]         nvarchar(max) COLLATE Chinese_PRC_CI_AS NULL,
    [Address]        nvarchar(300) COLLATE Chinese_PRC_CI_AS NULL,
    [ProjectID]      int          NULL,
    [StartTime]      datetime     NULL,
    [EndTime]        datetime     NULL,
    [Attribute]      bit          NULL,
    [Type]           int          NULL,
    [Status]         bit          NULL,
    [Tag]            int          NULL,
    [CooperatorList] nvarchar(300) COLLATE Chinese_PRC_CI_AS NULL,
    [IsAwake]        bit          NULL,
    [AwakeTime]      datetime     NULL,
    [ContractList]   nvarchar(50)  COLLATE Chinese_PRC_CI_AS NULL,
    [CreateDate]     datetime     NULL CONSTRAINT [DF_UDS_Task_CreateDate] default((getdate())),

    CONSTRAINT [PK_UDS_Assignment] PRIMARY KEY CLUSTERED ([ID] asc)
);
GO
